MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

6 rows where Artist Nationality = 94

View and edit SQL

Suggested facets: Is Public Domain, Department, Object Name, Culture, Artist Role, Object End Date, Medium, Credit Line, Classification

Link rowid ▼ Object Number Is Highlight Is Public Domain Object ID Department Object Name Title Culture Period Dynasty Reign Portfolio Artist Role Artist Prefix Artist Display Name Artist Display Bio Artist Suffix Artist Alpha Sort Artist Nationality Artist Begin Date Artist End Date Object Date Object Begin Date Object End Date Medium Dimensions Credit Line Geography Type City State County Country Region Subregion Locale Locus Excavation River Classification Rights and Reproduction Link Resource Repository
20093 36.120.413a–c 0 0 24618 Arms and Armor 5 Blade and mounting for a short sword (Wakizashi) 1294 Blade and Mounting for a Short Sword (Wakizashi) Japanese 35         Fittings maker|Fittings maker|Swordsmith|Fittings maker 134 Knife handle (kozuka) and grip ornaments (menuki) attributed to|Sword-hilt washer and pommel (fuchigashira) by|Blade inscribed by|Sword guard (tsuba) inscribed by Gotō Tokujō|Yokoya Munekuni|Nobukuni|Gotō Mitsuyoshi (Shinjō) Japanese, 1550–1631, fifth-generation Gotō master|Japanese, active 19th century|Japanese, active late 14th–early 15th century|Japanese, 1780–1843, fifteenth-generation Gotō master by Gotō Mitsuyoshi Tokujō Gotō|Yokoya Munekuni|Nobukuni|Gotō Mitsuyoshi (Shinjō) 2844 Japanese|Japanese|Japanese|Japanese 94 1550 |1801 |1350 |1780 1631 |1900 |1450 |1843 blade, late 14th–early 15th century; mounting, 19th century 1350 1900 Steel, wood, lacquer, ray skin (samé), thread, copper-gold alloy (shakudō), gold 4016 L. 26 11/16 in. (67.8 cm); L. of blade 19 in. (48.2 cm); L. of cutting edge 13 15/16 in. (35.4 cm); D. of curvature 3/16 in. (0.45 cm); L. scabbard 20 1/2 (52.1 cm); L. of knife (kozuka) L. 8 5/8 in. (21.9 cm) The Howard Mansfield Collection, Gift of Howard Mansfield, 1936                       Swords 29   Metropolitan Museum of Art, New York, NY 1
20104 36.120.412a, b 0 0 24629 Arms and Armor 5 Blade and mounting for a long sword (Katana) 2201 Blade and Mounting for a Long Sword (Katana) Japanese 35         Fittings maker|Swordsmith|Fittings maker|Fittings maker 136 Sword-hilt washer and pommel (fuchigashira) by|Blade inscribed by|Knife handle (kozuka) and grip ornaments (menuki) attributed to|Sword guard (tsuba) inscribed by Yokoya Munekuni|Muramasa|Gotō Tokujō|Gotō Mitsuyoshi (Shinjō) Japanese, active 19th century|Japanese, active 16th century|Japanese, 1550–1631, fifth-generation Gotō master|Japanese, 1780–1843, fifteenth-generation Gotō master   Yokoya Munekuni|Muramasa|Tokujō Gotō|Gotō Mitsuyoshi (Shinjō) 2848 Japanese|Japanese|Japanese|Japanese 94 1801 |1501 |1550 |1780 1900 |1600 |1631 |1843 blade, 16th century; mounting, 19th century 1501 1900 Steel, wood, lacquer, ray skin (samé), thread, copper-gold alloy (shakudō), gold 4016 L. 35 3/4 in. (90.8 cm); L. of blade 32 11/16 in. (83 cm); L. of cutting edge 25 5/32 in. (63.9 cm); D. of blade curvature 19/32 (1.5 cm) The Howard Mansfield Collection, Gift of Howard Mansfield, 1936                       Swords 29   Metropolitan Museum of Art, New York, NY 1
38941 1975.268.133 0 1 45183 Asian Art 7 Hanging scroll 3882   Japan 46 Edo period (1615–1868)       Artist|Artist|Artist|Artist 189   Tani Bunchō|Watanabe Kazan|Sakai Hōitsu|sixty-six others Japanese, 1763–1840|Japanese, 1793–1841|Japanese, 1761–1828|Japanese   Tani Bunchō|Watanabe Kazan|Sakai Hōitsu|sixty-six others 3795 Japanese|Japanese|Japanese|Japanese 94 1763 |1793 |1761 1840 |1841 |1828 1820 1820 1820 Hanging scroll; ink and color on paper 7241 Image: 31 3/8 x 23 3/8 in. (79.7 x 59.4 cm) Overall with mounting: 64 5/8 x 25 3/4 in. (164.1 x 65.4 cm) Overall with knobs: 64 5/8 x 28 1/8 in. (164.1 x 71.4 cm) The Harry G. C. Packard Collection of Asian Art, Gift of Harry G. C. Packard, and Purchase, Fletcher, Rogers, Harris Brisbane Dick, and Louis V. Bell Funds, Joseph Pulitzer Bequest, and The Annenberg Fund Inc. Gift, 1975                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
66227 2013.815 0 1 78705 Asian Art 7 Illustrated book 3906   Japan 46 Edo period (1615–1868)       Artist|Artist|Artist|Artist|Artist 188   Tsukioka Settei|Ōnishi Chinnen|Teisai Hokuba|Ikeda Koson|Nankō Japanese, 1710–1786|1792–1851|Japanese, 1771–1844|Japanese, 1803–1868|Japanese   Tsukioka Settei|Ōnishi Chinnen|Teisai Hokuba|Ikeda Koson|Nankō 5214 Japanese|Japanese|Japanese|Japanese 94 1710 |1792 |1771 |1803 1786 |1851 |1844 |1868 1830 1830 1830 Woodblock printed book (orihon, accordion-style); ink and color on paper 15014 10 1/16 × 6 11/16 in. (25.5 × 17 cm) Purchase, Mary and James G. Wallach Foundation Gift, 2013                       Illustrated Books 180   Metropolitan Museum of Art, New York, NY 1
66255 2013.843a, b 0 1 78733 Asian Art 7 Illustrated books 5103   Japan 46 Edo period (1615–1868)       Artist|Artist|Artist|Artist 189   Nukina Kaioku|Shiokawa Bunrin|Kawabata Gyokushō|Musō Soseki Japanese, 1778–1863|Japanese, 1808–1877|Japanese, 1842–1913|Japanese, 1275–1351 , et al Nukina Kaioku|Shiokawa Bunrin|Kawabata Gyokushō|Musō Soseki 5222 Japanese|Japanese|Japanese|Japanese 94 1778 |1808 |1842 |1275 1863 |1877 |1913 |1351 postscript dated 1861 1861 1861 Set of two woodblock printed books; ink and color on paper 15011 each: 10 3/16 × 6 11/16 in. (25.8 × 17 cm) Purchase, Mary and James G. Wallach Foundation Gift, 2013                       Illustrated Books 180   Metropolitan Museum of Art, New York, NY 1
66331 2013.793 0 1 78809 Asian Art 7 Illustrated book 3906 鳥文斎栄之・北川歌麿・礫川亭永理 葛飾北斎画  『男踏歌』|Men’s Stomping Dances (Otoko dōka) Japan 46 Edo period (1615–1868)       Artist|Artist|Artist|Artist 189   Rekisentei (Chōkyōsai) Eiri|Katsushika Hokusai|Chōbunsai Eishi|Kitagawa Utamaro Japanese, active ca. 1789–1801|Japanese, Tokyo (Edo) 1760–1849 Tokyo (Edo)|Japanese, 1756–1829|Japanese, ca. 1754–1806   Rekisentei Eiri|Katsushika Hokusai|Chōbunsai Eishi|Kitagawa Utamaro 5240 Japanese|Japanese|Japanese|Japanese 94 1789 |1760 |1756 |1754 1801 |1849 |1829 |1806 1798 1798 1798 Woodblock printed book; ink and color on paper 9286 10 1/16 × 7 1/2 in. (25.5 × 19 cm) Purchase, Mary and James G. Wallach Family Foundation Gift, in honor of John T. Carpenter, 2013                       Illustrated Books 180   Metropolitan Museum of Art, New York, NY 1

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "MetObjects" (
"Object Number" TEXT,
  "Is Highlight" INTEGER,
  "Is Public Domain" INTEGER,
  "Object ID" INTEGER,
  "Department" INTEGER,
  "Object Name" INTEGER,
  "Title" TEXT,
  "Culture" INTEGER,
  "Period" REAL,
  "Dynasty" INTEGER,
  "Reign" INTEGER,
  "Portfolio" INTEGER,
  "Artist Role" INTEGER,
  "Artist Prefix" REAL,
  "Artist Display Name" TEXT,
  "Artist Display Bio" TEXT,
  "Artist Suffix" REAL,
  "Artist Alpha Sort" INTEGER,
  "Artist Nationality" INTEGER,
  "Artist Begin Date" TEXT,
  "Artist End Date" TEXT,
  "Object Date" TEXT,
  "Object Begin Date" INTEGER,
  "Object End Date" INTEGER,
  "Medium" INTEGER,
  "Dimensions" TEXT,
  "Credit Line" TEXT,
  "Geography Type" INTEGER,
  "City" INTEGER,
  "State" INTEGER,
  "County" INTEGER,
  "Country" INTEGER,
  "Region" INTEGER,
  "Subregion" INTEGER,
  "Locale" INTEGER,
  "Locus" INTEGER,
  "Excavation" INTEGER,
  "River" INTEGER,
  "Classification" INTEGER,
  "Rights and Reproduction" REAL,
  "Link Resource" TEXT,
  "Metadata Date" TEXT,
  "Repository" INTEGER
,
FOREIGN KEY ("Department") REFERENCES [Department](id),
    FOREIGN KEY ("Object Name") REFERENCES [Object Name](id),
    FOREIGN KEY ("Culture") REFERENCES [Culture](id),
    FOREIGN KEY ("Dynasty") REFERENCES [Dynasty](id),
    FOREIGN KEY ("Reign") REFERENCES [Reign](id),
    FOREIGN KEY ("Portfolio") REFERENCES [Portfolio](id),
    FOREIGN KEY ("Artist Role") REFERENCES [Artist Role](id),
    FOREIGN KEY ("Artist Alpha Sort") REFERENCES [Artist Alpha Sort](id),
    FOREIGN KEY ("Artist Nationality") REFERENCES [Artist Nationality](id),
    FOREIGN KEY ("Medium") REFERENCES [Medium](id),
    FOREIGN KEY ("Geography Type") REFERENCES [Geography Type](id),
    FOREIGN KEY ("City") REFERENCES [City](id),
    FOREIGN KEY ("State") REFERENCES [State](id),
    FOREIGN KEY ("County") REFERENCES [County](id),
    FOREIGN KEY ("Country") REFERENCES [Country](id),
    FOREIGN KEY ("Region") REFERENCES [Region](id),
    FOREIGN KEY ("Subregion") REFERENCES [Subregion](id),
    FOREIGN KEY ("Locale") REFERENCES [Locale](id),
    FOREIGN KEY ("Locus") REFERENCES [Locus](id),
    FOREIGN KEY ("Excavation") REFERENCES [Excavation](id),
    FOREIGN KEY ("River") REFERENCES [River](id),
    FOREIGN KEY ("Classification") REFERENCES [Classification](id),
    FOREIGN KEY ("Repository") REFERENCES [Repository](id));
CREATE INDEX ["MetObjects_Department"] ON [MetObjects]("Department");
CREATE INDEX ["MetObjects_Object Name"] ON [MetObjects]("Object Name");
CREATE INDEX ["MetObjects_Culture"] ON [MetObjects]("Culture");
CREATE INDEX ["MetObjects_Dynasty"] ON [MetObjects]("Dynasty");
CREATE INDEX ["MetObjects_Reign"] ON [MetObjects]("Reign");
CREATE INDEX ["MetObjects_Portfolio"] ON [MetObjects]("Portfolio");
CREATE INDEX ["MetObjects_Artist Role"] ON [MetObjects]("Artist Role");
CREATE INDEX ["MetObjects_Artist Alpha Sort"] ON [MetObjects]("Artist Alpha Sort");
CREATE INDEX ["MetObjects_Artist Nationality"] ON [MetObjects]("Artist Nationality");
CREATE INDEX ["MetObjects_Medium"] ON [MetObjects]("Medium");
CREATE INDEX ["MetObjects_Geography Type"] ON [MetObjects]("Geography Type");
CREATE INDEX ["MetObjects_City"] ON [MetObjects]("City");
CREATE INDEX ["MetObjects_State"] ON [MetObjects]("State");
CREATE INDEX ["MetObjects_County"] ON [MetObjects]("County");
CREATE INDEX ["MetObjects_Country"] ON [MetObjects]("Country");
CREATE INDEX ["MetObjects_Region"] ON [MetObjects]("Region");
CREATE INDEX ["MetObjects_Subregion"] ON [MetObjects]("Subregion");
CREATE INDEX ["MetObjects_Locale"] ON [MetObjects]("Locale");
CREATE INDEX ["MetObjects_Locus"] ON [MetObjects]("Locus");
CREATE INDEX ["MetObjects_Excavation"] ON [MetObjects]("Excavation");
CREATE INDEX ["MetObjects_River"] ON [MetObjects]("River");
CREATE INDEX ["MetObjects_Classification"] ON [MetObjects]("Classification");
CREATE INDEX ["MetObjects_Repository"] ON [MetObjects]("Repository");
CREATE INDEX metobjects_IsHighlight ON MetObjects("Is Highlight");
CREATE INDEX metobjects_IsPublicDomain ON MetObjects("Is Public Domain");
CREATE INDEX metobjects_Department ON MetObjects("Department");
CREATE INDEX metobjects_Culture ON MetObjects("Culture");
CREATE INDEX metobjects_Period ON MetObjects("Period");
CREATE INDEX metobjects_Dynasty ON MetObjects("Dynasty");
CREATE INDEX metobjects_Medium ON MetObjects("Medium");
CREATE INDEX metobjects_City ON MetObjects("City");
CREATE INDEX metobjects_State ON MetObjects("State");
CREATE INDEX metobjects_County ON MetObjects("County");
CREATE INDEX metobjects_Country ON MetObjects("Country");
CREATE INDEX metobjects_Region ON MetObjects("Region");
CREATE INDEX metobjects_Subregion ON MetObjects("Subregion");
CREATE INDEX metobjects_Locale ON MetObjects("Locale");
CREATE INDEX metobjects_Locus ON MetObjects("Locus");
CREATE INDEX metobjects_Excavation ON MetObjects("Excavation");
CREATE INDEX metobjects_River ON MetObjects("River");
Powered by Datasette · Query took 134.896ms · Data license: CC0 · Data source: metmuseum/openaccess